package org.zero.provider;

/**
 * SQL 语句提供者
 * 可在此提供动态 SQL
 *
 * @author Zero (cnzeropro@qq.com)
 * @date 2021/9/11 13:27
 */
public class SqlProvider {

    public static String select() {
        return "select * from user where id=#{uid}";
    }

    public static String insert() {
        return "insert into user(name,email,gender,birthday) values(#{name},#{email},#{gender},#{birthday})";
    }

    public static String update() {
        return "update user set name=#{name},email=#{email},gender=#{gender},birthday=#{birthday} where id=#{id}";
    }

    public static String delete() {
        return "delete from user where id=#{uid}";
    }
}

